let staffSQLMap = new Map()
staffSQLMap.set("GetStaffPasswordByStaffID","select password from staff where id = ?")
staffSQLMap.set("GetSameEmailNums","select  count(*) as same_email_nums from staff where email = ?")
staffSQLMap.set("InsertStaff","INSERT INTO MissionManagermentSystem.staff (id, name, email, password) VALUES (?, ?, ?, ?)")
staffSQLMap.set("GetStaffPasswordByStaffEmail","select password from staff where email = ?")
staffSQLMap.set("GetStaffNameByStaffEmail","select name from staff where id = ?")
staffSQLMap.set("GetStaffIDByStaffEmail","select id from staff where email = ?")
staffSQLMap.set("CatStaff","SELECT id,name,email FROM MissionManagermentSystem.staff where id = ?")
staffSQLMap.set("CatAllStaff","SELECT id,name,email FROM MissionManagermentSystem.staff")
staffSQLMap.set("updateStaff","UPDATE MissionManagermentSystem.staff t SET t.name = ?, t.email = ? WHERE t.id = ?")
module.exports=staffSQLMap